﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using DataAccess;

namespace BLL
{
    public class BLL
    {
       // public DAL ac = new DAL();
        public DataAccess.DataAccess  ac= new DataAccess.DataAccess();
        public void Insert(string ID, string Pass)
        {

            string sql = "Insert into Accout values('" + ID + "','" + Pass + "')";
            ac.KetNoi();
            ac.ExcuteNonQuery(sql);
        }
        public void Update(string Id, string Pass)
        {
            string sql = "Update Accout set Pass='" + Pass + "' where Id='" + Id + "'";
            ac.KetNoi();
            ac.ExcuteNonQuery(sql);
        }
        public void Delete(string Id)
        {
            string sql = "Detele from accout where ID='" + Id + "'";
        }
        public  DataTable ShowDataTable(string sql)
        {

            return ac.LayDuLieu(sql);
        }
        
    }
}
